explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ecj1 : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 354.371 ↑ 1.0 10 1

Limit (cost=0.57..313.25 rows=10 width=86) (actual time=0.118..354.371 rows=10 loops=1)

2. 0.550 354.365 ↑ 1,051,646.1 10 1

Nested Loop (cost=0.57..328,827,804.10 rows=10,516,461 width=86) (actual time=0.117..354.365 rows=10 loops=1)

3. 22.612 22.612 ↑ 133,447.1 339 1

Seq Scan on erp_eventlog_data_changes elogdata (cost=0.00..28,644,224.66 rows=45,238,576 width=82) (actual time=0.014..22.612 rows=339 loops=1)

  • Filter: ((field)::text = ANY ('{status,manualProcessingStatus}'::text[]))
  • Rows Removed by Filter: 21594
4. 331.203 331.203 ↓ 0.0 0 339

Index Scan using erp_eventlog_pkey on erp_eventlog elog (cost=0.57..6.63 rows=1 width=12) (actual time=0.977..0.977 rows=0 loops=339)

  • Index Cond: (id = elogdata.event_id)
  • Filter: ((object_class)::text = 'Applications\Entity\Application'::text)
  • Rows Removed by Filter: 1