explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oPX9

Settings
# exclusive inclusive rows x rows loops node
1. 42.184 468,851.004 ↑ 1.0 1 1

Aggregate (cost=677,726.95..677,726.96 rows=1 width=16) (actual time=468,851.003..468,851.004 rows=1 loops=1)

2. 223.382 468,808.820 ↓ 1.6 47,060 1

Nested Loop (cost=2,370.22..677,651.79 rows=30,064 width=0) (actual time=2,478.917..468,808.820 rows=47,060 loops=1)

3. 32,187.349 34,619.872 ↓ 1.3 78,989 1

Bitmap Heap Scan on docs_executive e (cost=2,369.66..201,220.33 rows=62,094 width=6) (actual time=2,465.719..34,619.872 rows=78,989 loops=1)

  • Recheck Cond: (status_id = '1'::numeric)
  • Heap Blocks: exact=61621
4. 2,432.523 2,432.523 ↓ 1.3 80,023 1

Bitmap Index Scan on docs_executive_status_id (cost=0.00..2,354.13 rows=62,094 width=0) (actual time=2,432.523..2,432.523 rows=80,023 loops=1)

  • Index Cond: (status_id = '1'::numeric)
5. 433,965.566 433,965.566 ↑ 1.0 1 78,989

Index Scan using delo_pkey on delo d (cost=0.56..7.66 rows=1 width=6) (actual time=5.457..5.494 rows=1 loops=78,989)

  • Index Cond: (delo_id = e.delo_id)
  • Filter: ((ogai_nah_kod)::text = '45592'::text)
  • Rows Removed by Filter: 0
Planning time : 1.060 ms
Execution time : 468,851.071 ms