explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QMvX : 8.5

Settings
# exclusive inclusive rows x rows loops node
1. 50.831 1,037.915 ↑ 1.0 301,280 1

Unique (cost=78,598.35..85,377.87 rows=301,312 width=41) (actual time=674.253..1,037.915 rows=301,280 loops=1)

2. 278.145 987.084 ↓ 1.1 329,000 1

WindowAgg (cost=78,598.35..84,624.59 rows=301,312 width=41) (actual time=674.251..987.084 rows=329,000 loops=1)

3. 150.107 708.939 ↓ 1.1 329,000 1

Sort (cost=78,598.35..79,351.63 rows=301,312 width=49) (actual time=674.231..708.939 rows=329,000 loops=1)

  • Sort Key: task.task_id
  • Sort Method: external merge Disk: 14112kB
4. 48.047 558.832 ↓ 1.1 329,000 1

Hash Left Join (cost=16,883.74..51,177.61 rows=301,312 width=49) (actual time=123.154..558.832 rows=329,000 loops=1)

  • Hash Cond: (customer.customer_id = customer_add.customer_id)
5. 62.280 510.722 ↑ 1.0 301,280 1

Hash Left Join (cost=16,876.92..49,248.14 rows=301,312 width=49) (actual time=123.073..510.722 rows=301,280 loops=1)

  • Hash Cond: (COALESCE(project.customer_id, quote.customer_id) = customer.customer_id)
6. 49.929 411.936 ↑ 1.0 301,280 1

Hash Left Join (cost=11,463.16..43,043.23 rows=301,312 width=24) (actual time=86.507..411.936 rows=301,280 loops=1)

  • Hash Cond: (task.quote_id = quote.quote_id)
7. 214.727 334.739 ↑ 1.0 301,280 1

Hash Left Join (cost=7,673.51..38,462.61 rows=301,312 width=24) (actual time=59.058..334.739 rows=301,280 loops=1)

  • Hash Cond: (task.project_id = project.project_id)
8. 61.422 61.422 ↑ 1.0 301,280 1

Seq Scan on task (cost=0.00..29,998.12 rows=301,312 width=24) (actual time=0.012..61.422 rows=301,280 loops=1)

9. 13.971 58.590 ↓ 1.0 97,757 1

Hash (cost=6,451.56..6,451.56 rows=97,756 width=16) (actual time=58.590..58.590 rows=97,757 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5607kB
10. 44.619 44.619 ↓ 1.0 97,757 1

Seq Scan on project (cost=0.00..6,451.56 rows=97,756 width=16) (actual time=0.015..44.619 rows=97,757 loops=1)

11. 6.133 27.268 ↑ 1.0 50,340 1

Hash (cost=3,160.40..3,160.40 rows=50,340 width=16) (actual time=27.268..27.268 rows=50,340 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2872kB
12. 21.135 21.135 ↑ 1.0 50,340 1

Seq Scan on quote (cost=0.00..3,160.40 rows=50,340 width=16) (actual time=0.013..21.135 rows=50,340 loops=1)

13. 2.734 36.506 ↑ 1.0 16,345 1

Hash (cost=5,209.45..5,209.45 rows=16,345 width=41) (actual time=36.506..36.506 rows=16,345 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1150kB
14. 33.772 33.772 ↑ 1.0 16,345 1

Seq Scan on customer (cost=0.00..5,209.45 rows=16,345 width=41) (actual time=0.012..33.772 rows=16,345 loops=1)

15. 0.028 0.063 ↑ 1.0 214 1

Hash (cost=4.14..4.14 rows=214 width=16) (actual time=0.063..0.063 rows=214 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
16. 0.035 0.035 ↑ 1.0 214 1

Seq Scan on customer_additional_persons_responsible customer_add (cost=0.00..4.14 rows=214 width=16) (actual time=0.014..0.035 rows=214 loops=1)

Planning time : 6.525 ms
Execution time : 1,047.521 ms