explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wD8h

Settings
# exclusive inclusive rows x rows loops node
1. 4.138 55,625.282 ↑ 125.0 6 1

Subquery Scan on pdt (cost=0.71..58,944.17 rows=750 width=90) (actual time=1,028.797..55,625.282 rows=6 loops=1)

  • Filter: (pdt.person_id = 6051063)
  • Rows Removed by Filter: 54644
2. 8.054 55,621.144 ↑ 2.7 54,650 1

Result (cost=0.71..57,069.17 rows=150,000 width=98) (actual time=158.791..55,621.144 rows=54,650 loops=1)

3. 55,559.996 55,613.090 ↑ 2.7 54,650 1

ProjectSet (cost=0.71..18,069.17 rows=150,000 width=122) (actual time=158.781..55,613.090 rows=54,650 loops=1)

4. 8.547 53.094 ↓ 8.6 1,289 1

Nested Loop (cost=0.71..17,280.92 rows=150 width=90) (actual time=26.544..53.094 rows=1,289 loops=1)

5. 4.626 4.626 ↑ 1.0 5,703 1

Index Only Scan using dyn_tms_pk on dyn_tms dt (cost=0.28..114.33 rows=5,703 width=8) (actual time=0.064..4.626 rows=5,703 loops=1)

  • Heap Fetches: 0
6. 39.921 39.921 ↓ 0.0 0 5,703

Index Scan using recipients_rid_when_updated_desc_pidx on recipients r (cost=0.43..3.01 rows=1 width=90) (actual time=0.007..0.007 rows=0 loops=5,703)

  • Index Cond: (recipient_id = dt.dyn_tm_id)
  • Filter: (org_id = 200424)
  • Rows Removed by Filter: 1
Planning time : 4.370 ms
Execution time : 55,627.446 ms