explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LQZG : test

Settings
# exclusive inclusive rows x rows loops node
1. 118.564 1,499.843 ↑ 16,666.5 2 1

Hash Join (cost=26,565.98..32,811.31 rows=33,333 width=32) (actual time=1,453.772..1,499.843 rows=2 loops=1)

  • Hash Cond: ("TransactionLines"."TaxReturnImportPartTransactionId" = duplicates.id)
2. 114.538 114.538 ↑ 1.0 100,000 1

Seq Scan on "TransactionLines" (cost=0.00..5,537.00 rows=100,000 width=32) (actual time=0.010..114.538 rows=100,000 loops=1)

3. 0.018 1,266.741 ↑ 16,666.5 2 1

Hash (cost=26,149.32..26,149.32 rows=33,333 width=16) (actual time=1,266.740..1,266.741 rows=2 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 513kB
4. 118.456 1,266.723 ↑ 16,666.5 2 1

Subquery Scan on duplicates (cost=21,399.32..26,149.32 rows=33,333 width=16) (actual time=999.367..1,266.723 rows=2 loops=1)

  • Filter: (duplicates."rowNumber" > 1)
  • Rows Removed by Filter: 100000
5. 279.305 1,148.267 ↓ 1.0 100,002 1

WindowAgg (cost=21,399.32..24,899.32 rows=100,000 width=105) (actual time=643.192..1,148.267 rows=100,002 loops=1)

6. 698.570 868.962 ↓ 1.0 100,002 1

Sort (cost=21,399.32..21,649.32 rows=100,000 width=97) (actual time=643.184..868.962 rows=100,002 loops=1)

  • Sort Key: "TaxReturnImportPartTransactions"."CompanyId", "TaxReturnImportPartTransactions"."sourceAccount", "TaxReturnImportPartTransactions".transaction, "TaxReturnImportPartTransactions"."taxDate", "TaxReturnImportPartTransactions"."inputOutputIndicator", "TaxReturnImportPartTransactions"."lineNumber", "TaxReturnImportPartTransactions"."createdAt" DESC
  • Sort Method: external merge Disk: 11120kB
7. 170.392 170.392 ↓ 1.0 100,002 1

Seq Scan on "TaxReturnImportPartTransactions" (cost=0.00..7,624.00 rows=100,000 width=97) (actual time=0.019..170.392 rows=100,002 loops=1)

  • Filter: ("TaxReturnImportPartId" = '9fa40410-d2e9-11e9-ae74-5906b0617687'::uuid)
Planning time : 0.525 ms
Execution time : 1,502.678 ms