explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X7cB

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

Limit (cost=0.85..3.15 rows=1 width=655) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..418,277.66 rows=182,157 width=655) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using idx_service_output_id on service_output a (cost=0.43..246,336.58 rows=182,157 width=381) (actual rows= loops=)

  • Filter: ((postprocess_start_time IS NULL) AND (service_name = ANY ('{filtered,exif,file_type,report_type,image_classifier,video_classifier,tika,s3_location,archive_location}'::text[])))
4. 0.000 0.000 ↓ 0.0

Index Scan using reports_eventid_key on file_event b (cost=0.42..0.94 rows=1 width=274) (actual rows= loops=)

  • Index Cond: (eventid = a.file_id)