explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SUC5

Settings
# exclusive inclusive rows x rows loops node
1. 796.702 1,580.977 ↑ 61.9 21 1

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

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.040 784.275 ↑ 61.9 21 1 / 2

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

3. 0.059 0.264 ↓ 21.0 21 1 / 2

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

4. 0.066 0.066 ↓ 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.032..0.132 rows=23 loops=1)

  • Index Cond: (((state)::text = 'UK'::text) AND (traffic_police = 0))
5. 0.138 0.138 ↑ 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.012..0.012 rows=1 loops=23)

  • Index Cond: (id = offences_penalty_extended.offence_id)
  • Filter: (((state)::text = 'UK'::text) AND (traffic_police = 0))
6. 783.972 783.972 ↑ 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.043..74.664 rows=1 loops=21)

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