explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EsSL

Settings
# exclusive inclusive rows x rows loops node
1. 46.793 184.628 ↑ 1.0 10,162 1

GroupAggregate (cost=7,689.52..8,608.06 rows=10,206 width=1,192) (actual time=135.769..184.628 rows=10,162 loops=1)

  • Group Key: ap.org_id, ap.uuid, mp.message_panel_id, ps.uuid, 'Recipients'::text, ps.order_num, ps.type, ps.is_visible, ps.is_collapsed, 30, 'recipients'::text, NULL::text, 3, 'N'::text, NULL::numeric, ((uuid_generate_v5((mp.uuid)::uuid, 'recipients_property'::text))::text), 0
2. 15.805 137.835 ↓ 1.3 13,071 1

Sort (cost=7,689.52..7,715.04 rows=10,206 width=393) (actual time=135.734..137.835 rows=13,071 loops=1)

  • Sort Key: ap.org_id, ap.uuid, mp.message_panel_id, ps.uuid, ps.order_num, ps.is_visible, ps.is_collapsed, ((uuid_generate_v5((mp.uuid)::uuid, 'recipients_property'::text))::text)
  • Sort Method: quicksort Memory: 5,734kB
3. 37.336 122.030 ↓ 1.3 13,071 1

Hash Join (cost=5,813.62..7,009.95 rows=10,206 width=393) (actual time=76.937..122.030 rows=13,071 loops=1)

  • Hash Cond: (ps.message_panel_id = mp.message_panel_id)
4. 7.811 7.811 ↑ 1.0 10,162 1

Seq Scan on panel_section ps (cost=0.00..928.90 rows=10,206 width=57) (actual time=0.009..7.811 rows=10,162 loops=1)

  • Filter: (type = '2'::numeric)
  • Rows Removed by Filter: 23,435
5. 3.982 76.883 ↓ 1.3 13,087 1

Hash (cost=5,686.91..5,686.91 rows=10,137 width=139) (actual time=76.883..76.883 rows=13,087 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,066kB
6. 6.154 72.901 ↓ 1.3 13,087 1

Hash Join (cost=5,396.44..5,686.91 rows=10,137 width=139) (actual time=55.276..72.901 rows=13,087 loops=1)

  • Hash Cond: (mp.application_id = ap.application_id)
7. 5.417 63.678 ↓ 1.3 13,087 1

Hash Right Join (cost=5,093.07..5,356.91 rows=10,137 width=115) (actual time=52.189..63.678 rows=13,087 loops=1)

  • Hash Cond: (mpr.message_panel_id = mp.message_panel_id)
8. 1.352 52.495 ↓ 1.0 7,512 1

Hash Left Join (cost=4,567.99..4,812.17 rows=7,486 width=72) (actual time=46.382..52.495 rows=7,512 loops=1)

  • Hash Cond: (r.org_dvc_name_id = odn.org_dvc_name_id)
9. 3.914 48.724 ↓ 1.0 7,512 1

Hash Left Join (cost=4,251.18..4,475.69 rows=7,486 width=70) (actual time=43.931..48.724 rows=7,512 loops=1)

  • Hash Cond: (mpr.recipient_id = r.recipient_id)
10. 0.998 0.998 ↓ 1.0 7,512 1

Seq Scan on message_panel_recipient mpr (cost=0.00..204.86 rows=7,486 width=15) (actual time=0.012..0.998 rows=7,512 loops=1)

11. 16.094 43.812 ↓ 1.0 62,428 1

Hash (cost=3,471.31..3,471.31 rows=62,389 width=71) (actual time=43.812..43.812 rows=62,428 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 6,816kB
12. 27.718 27.718 ↓ 1.0 62,428 1

Seq Scan on recipients r (cost=0.00..3,471.31 rows=62,389 width=71) (actual time=0.008..27.718 rows=62,428 loops=1)

  • Filter: (deleted_id = '-1'::integer)
  • Rows Removed by Filter: 18,898
13. 0.908 2.419 ↓ 1.0 6,723 1

Hash (cost=233.03..233.03 rows=6,703 width=18) (actual time=2.419..2.419 rows=6,723 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 425kB
14. 1.511 1.511 ↓ 1.0 6,723 1

Seq Scan on org_dvc_names odn (cost=0.00..233.03 rows=6,703 width=18) (actual time=0.011..1.511 rows=6,723 loops=1)

15. 2.304 5.766 ↓ 1.0 10,178 1

Hash (cost=398.37..398.37 rows=10,137 width=50) (actual time=5.766..5.766 rows=10,178 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 953kB
16. 3.462 3.462 ↓ 1.0 10,178 1

Seq Scan on message_panel mp (cost=0.00..398.37 rows=10,137 width=50) (actual time=0.011..3.462 rows=10,178 loops=1)

17. 1.202 3.069 ↓ 1.0 5,884 1

Hash (cost=229.83..229.83 rows=5,883 width=30) (actual time=3.069..3.069 rows=5,884 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 427kB
18. 1.867 1.867 ↓ 1.0 5,884 1

Seq Scan on application ap (cost=0.00..229.83 rows=5,883 width=30) (actual time=0.005..1.867 rows=5,884 loops=1)

Planning time : 1.656 ms
Execution time : 185.337 ms