explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dtb1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5,961.220 ↑ 1.0 1 1

Finalize Aggregate (cost=176,093.67..176,093.68 rows=1 width=4) (actual time=5,961.220..5,961.220 rows=1 loops=1)

2. 310.682 6,215.402 ↓ 1.5 3 1

Gather (cost=176,093.47..176,093.67 rows=2 width=4) (actual time=5,910.521..6,215.402 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 28.932 5,904.720 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=175,093.47..175,093.47 rows=1 width=4) (actual time=5,904.720..5,904.720 rows=1 loops=3)

4. 1,688.703 5,875.788 ↓ 5.4 647,819 3 / 3

Parallel Hash Join (cost=105,375.76..174,796.05 rows=118,966 width=4) (actual time=4,834.660..5,875.788 rows=647,819 loops=3)

  • Hash Cond: (challan_in_court.challan_id = challans.id)
  • -> Parallel Seq Scan on challan_in_court (cost=0.00..61711.81 rows=2,015,938 width=8) (actual time=0.021..119.714 rows=16
5. 1,383.834 4,187.085 ↓ 3.3 3,287,197 3 / 3

Parallel Hash (cost=99,816.39..99,816.39 rows=1,010,796 width=4) (actual time=4,187.085..4,187.085 rows=3,287,197 loops=3)

  • Buckets: 4,194,304 (originally 4194304) Batches: 8 (originally 1) Memory Usage: 81,088kB
6. 2,779.322 2,803.251 ↓ 3.3 3,287,197 3 / 3

Nested Loop (cost=36.30..99,816.39 rows=1,010,796 width=4) (actual time=1.923..2,803.251 rows=3,287,197 loops=3)

  • -> Index Only Scan using challans_vc_compare1 on challans (cost=0.56..55.40 rows=3,412 width=8) (actual time
7. 23.008 23.929 ↓ 5.3 7,937 3 / 3

Merge Join (cost=35.73..1,420.63 rows=1,499 width=4) (actual time=1.862..23.929 rows=7,937 loops=3)

  • Merge Cond: ((users.location)::text = (((rto.id)::character varying)::text))
  • -> Parallel Index Only Scan using users_compare on users (cost=0.41..1175.36 rows=25,396 width=8) (act
  • Heap Fetches: 30,221
  • Index Cond: (officer_id = users.id)
  • Heap Fetches: 1,497,003
8. 0.921 0.921 ↓ 139.6 7,678 3 / 3

Sort (cost=35.32..35.45 rows=55 width=4) (actual time=0.240..0.921 rows=7,678 loops=3)

  • Sort Key: (((rto.id)::character varying)::text)
  • Sort Method: quicksort Memory: 28kB
  • Worker 0: Sort Method: quicksort Memory: 28kB
  • Worker 1: Sort Method: quicksort Memory: 28kB
  • -> Bitmap Heap Scan on rto (cost=3.47..33.73 rows=55 width=4) (actual time=0.079..0.128 rows=81
  • Recheck Cond: ((state_code)::text = 'UP'::text)
  • Filter: (type = 2)
  • Rows Removed by Filter: 76
  • Heap Blocks: exact=9
  • -> Bitmap Index Scan on rto_state_code_id_idx (cost=0.00..3.46 rows=157 width=0) (actual
  • Index Cond: ((state_code)::text = 'UP'::text)
Planning time : 2.582 ms
Execution time : 6,215.615 ms