explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z7ji

Settings
# exclusive inclusive rows x rows loops node
1. 781.086 1,550.365 ↑ 61.9 21 1

Gather (cost=1,000.98..15,235.34 rows=1,300 width=531) (actual time=2.945..1,550.365 rows=21 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.032 769.279 ↑ 61.9 21 1 / 2

Nested Loop (cost=0.98..14,105.34 rows=1,300 width=531) (actual time=0.129..1,538.559 rows=21 loops=1)

3. 0.046 0.281 ↓ 21.0 21 1 / 2

Nested Loop (cost=0.55..55.54 rows=1 width=495) (actual time=0.074..0.561 rows=21 loops=1)

4. 0.086 0.086 ↓ 1.2 23 1 / 2

Index Scan using offences_penalty_extended_index on offences_penalty_extended (cost=0.27..14.90 rows=19 width=239) (actual time=0.036..0.171 rows=23 loops=1)

  • Index Cond: (((state)::text = 'UK'::text) AND (traffic_police = 0))
5. 0.149 0.149 ↑ 1.0 1 23 / 2

Index Scan using offences_copy_pkey on offences (cost=0.28..2.14 rows=1 width=260) (actual time=0.013..0.013 rows=1 loops=23)

  • Index Cond: (id = offences_penalty_extended.offence_id)
  • Filter: ((traffic_police = 0) AND ((state)::text = 'UK'::text))
6. 768.967 768.967 ↑ 1,300.0 1 21 / 2

Index Scan using extended_offences_fine_index on extended_offences_fine (cost=0.43..14,045.90 rows=1,300 width=40) (actual time=0.040..73.235 rows=1 loops=21)

  • Index Cond: (offence_id = offences_penalty_extended.id)
Planning time : 0.989 ms
Execution time : 1,550.430 ms