explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2oHX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.009 ↓ 0.0 0 1

Unique (cost=22,746.77..22,747.37 rows=119 width=112) (actual time=0.009..0.009 rows=0 loops=1)

2.          

Initplan (for Unique)

3. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=21,260.04..21,260.05 rows=1 width=8) (never executed)

4. 0.000 0.000 ↓ 0.0 0

Index Scan using core_contact_control_system_process_indx on core_contact_control core_contact_control_1 (cost=0.56..21,226.75 rows=13,314 width=8) (never executed)

  • Index Cond: ((system_process)::text = 'I172_core_contact_sector_specific_demographic_response'::text)
  • Filter: ((process_flag)::text = 'PP'::text)
5. 0.004 0.009 ↓ 0.0 0 1

Sort (cost=1,486.73..1,487.02 rows=119 width=112) (actual time=0.009..0.009 rows=0 loops=1)

  • Sort Key: cth.contact_id
  • Sort Method: quicksort Memory: 25kB
6. 0.000 0.005 ↓ 0.0 0 1

Nested Loop Semi Join (cost=913.16..1,482.62 rows=119 width=112) (actual time=0.005..0.005 rows=0 loops=1)

7. 0.001 0.005 ↓ 0.0 0 1

Hash Join (cost=912.60..1,256.86 rows=119 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Hash Cond: (drv.contact_id = cth.contact_id)
8. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on core_contact_driver_all_temp drv (cost=0.00..249.78 rows=24,878 width=8) (actual time=0.004..0.004 rows=0 loops=1)

9. 0.000 0.000 ↓ 0.0 0

Hash (cost=906.60..906.60 rows=480 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..906.60 rows=480 width=8) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on staging_contact_sector_specific_demographic_response cipsdmrs (cost=0.00..14.80 rows=480 width=8) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using core_contact_transaction_history_contact_transaction_id_indx on contact_transaction_history cth (cost=0.29..1.86 rows=1 width=16) (never executed)

  • Index Cond: (contact_transaction_id = cipsdmrs.contact_transaction_id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_core_contact_control_cntid_flag_process on core_contact_control (cost=0.56..1.88 rows=1 width=8) (never executed)

  • Index Cond: ((contact_id = cth.contact_id) AND ((process_flag)::text = 'CP'::text) AND ((system_process)::text = 'I120_core_contact_session_history'::text))
  • Filter: (activity_time > COALESCE($0, '1900-01-01 00:00:00'::timestamp without time zone))