explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FsCq

Settings
# exclusive inclusive rows x rows loops node
1. 0.114 0.910 ↓ 1.1 342 1

Sort (cost=128.25..129.04 rows=315 width=1,353) (actual time=0.896..0.910 rows=342 loops=1)

  • Sort Key: it."orderRef
  • Sort Method: quicksort Memory: 115kB
2. 0.022 0.796 ↓ 1.1 342 1

Append (cost=19.09..115.18 rows=315 width=1,353) (actual time=0.445..0.796 rows=342 loops=1)

3. 0.000 0.267 ↓ 0.0 0 1

Nested Loop Left Join (cost=19.09..39.94 rows=1 width=1,312) (actual time=0.267..0.267 rows=0 loops=1)

4. 0.000 0.267 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.95..39.73 rows=1 width=1,288) (actual time=0.267..0.267 rows=0 loops=1)

5. 0.031 0.267 ↓ 0.0 0 1

Hash Join (cost=18.82..39.53 rows=1 width=772) (actual time=0.267..0.267 rows=0 loops=1)

  • Hash Cond: (it."orderRef" = odo.id)
6. 0.075 0.075 ↑ 1.0 342 1

Seq Scan on "InvoicingTransmissionDO" it (cost=0.00..19.42 rows=342 width=725) (actual time=0.003..0.075 rows=342 loops=1)

7. 0.031 0.161 ↑ 1.0 303 1

Hash (cost=15.03..15.03 rows=303 width=55) (actual time=0.161..0.161 rows=303 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
8. 0.130 0.130 ↑ 1.0 303 1

Seq Scan on "OrderDO" odo (cost=0.00..15.03 rows=303 width=55) (actual time=0.018..0.130 rows=303 loops=1)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using "TransmissionResponseStateDefDO_pkey" on "TransmissionResponseStateDefDO" i_trs (cost=0.13..0.19 rows=1 width=520) (never executed)

  • Index Cond: (it."transmissionResponseStateDefRef" = id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using "TransmissionTypeDefDO_pkey" on "TransmissionTypeDefDO" i_tt (cost=0.14..0.21 rows=1 width=28) (never executed)

  • Index Cond: (it."transmissionTypeDefRef" = id)
11. 0.108 0.507 ↓ 1.1 342 1

Hash Left Join (cost=38.25..72.09 rows=314 width=1,312) (actual time=0.177..0.507 rows=342 loops=1)

  • Hash Cond: (i2o."orderRef" = odo_2.id)
12. 0.056 0.319 ↓ 1.1 342 1

Hash Left Join (cost=19.43..48.95 rows=314 width=1,273) (actual time=0.095..0.319 rows=342 loops=1)

  • Hash Cond: (it_1."transmissionTypeDefRef" = i_tt_1.id)
13. 0.058 0.243 ↓ 1.1 342 1

Hash Left Join (cost=15.18..40.39 rows=314 width=1,249) (actual time=0.072..0.243 rows=342 loops=1)

  • Hash Cond: (it_1."transmissionResponseStateDefRef" = i_trs_1.id)
14. 0.086 0.183 ↓ 1.1 342 1

Hash Join (cost=14.07..37.91 rows=314 width=733) (actual time=0.067..0.183 rows=342 loops=1)

  • Hash Cond: (it_1."invoicingRef" = i2o."invoicingRef")
15. 0.035 0.035 ↑ 1.0 342 1

Seq Scan on "InvoicingTransmissionDO" it_1 (cost=0.00..19.42 rows=342 width=733) (actual time=0.001..0.035 rows=342 loops=1)

16. 0.027 0.062 ↓ 1.1 348 1

Hash (cost=10.14..10.14 rows=314 width=16) (actual time=0.062..0.062 rows=348 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
17. 0.035 0.035 ↓ 1.1 348 1

Seq Scan on "Invoicing2OrderDO" i2o (cost=0.00..10.14 rows=314 width=16) (actual time=0.004..0.035 rows=348 loops=1)

18. 0.001 0.002 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=520) (actual time=0.002..0.002 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.001 0.001 ↑ 1.0 5 1

Seq Scan on "TransmissionResponseStateDefDO" i_trs_1 (cost=0.00..1.05 rows=5 width=520) (actual time=0.001..0.001 rows=5 loops=1)

20. 0.014 0.020 ↑ 1.0 100 1

Hash (cost=3.00..3.00 rows=100 width=28) (actual time=0.020..0.020 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
21. 0.006 0.006 ↑ 1.0 100 1

Seq Scan on "TransmissionTypeDefDO" i_tt_1 (cost=0.00..3.00 rows=100 width=28) (actual time=0.002..0.006 rows=100 loops=1)

22. 0.032 0.080 ↑ 1.0 303 1

Hash (cost=15.03..15.03 rows=303 width=47) (actual time=0.080..0.080 rows=303 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
23. 0.048 0.048 ↑ 1.0 303 1

Seq Scan on "OrderDO" odo_2 (cost=0.00..15.03 rows=303 width=47) (actual time=0.002..0.048 rows=303 loops=1)

Planning time : 11.967 ms
Execution time : 0.997 ms